Release 10.1A: OpenEdge Development:
ADM and SmartObjects

Single-row operations

If you want to receive and return data a row at a time, use the colValues function to obtain desired column values for the current row in the data set, then use the fetchFirst, fetchNext, fetchPrev, fetchLast, and fetchRowIdent procedures to reposition the SmartDataObject’s query. Additional batches of rows are moved from the database query into the RowObject temp-table query automatically as necessary. To perform updates to individual rows, use the submitRow function to return updated values for a single row to the SmartDataObject. You can use the deleteRow procedure to delete the current row. You also use the addRow and copyRow procedures to create new rows starting with the initial values for the table or with the values from the previous current row. After these initial values have been returned to the caller, use the submitRow function to send the final field values back to the SmartDataObject to be written to the database.

Special considerations apply when you access a SmartDataObject from a Java application. For details, see the "Java applications and SmartDataObjects" section.